Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

Insert Update Delete
1) Change multiple columns using one statement
2) Commit a transaction
3) Copying Tables with auto_increment column
4) Create a save point
5) Delete on row with LOW_PRIORITY
6) Delete statement based on table joins
7) Delete statement based on table joins (tableName )
8) Do calculation in the insert statement referencing the column name
9) Insert aTable into select from anotherTable
10) Insert double quotation mark by using the single quote
11) Insert more than one rows in a single insert statement
12) Insert NULL to a NOT NULL column
13) Insert quotation marks
14) Insert single quotation mark by using the double quote
15) Insert statement with set statement and default value
16) Insert two rows with one insert statement
17) Insert with set statement
18) INSERTing data
19) REPLACE INTO
20) Rollback a transaction
21) Rollback to the save point
22) Syntac for UPDATE statement
23) The DELETE statement
24) Update a value based on the value it currently holds
25) Update only 5 records
26) Update two tables in one update statement
27) UPDATE-ing Records
28) Use the DEFAULT in the insert statement
29) Use the LIMIT function to control the number of rows that are affected by your UPDATE statement
30) Using encode function with insert statement
31) Using the LIMIT keyword to ensure only the number of rows you specify are deleted
32) Without the WHERE clause, all records from the database are deleted by default